package com.anolesoft.yr.mbus.prod.pack.sql;

public class ProdPackageRelSQL {

    //新增产品套餐服务关系信息表
    public static final String SAVE_PROD_PACKAGE_REL = "insert into prod_package_rel(objuid,fac_code,prod_package_uid,prod_package_service_uid) values(#{objuid},#{facCode},#{prodPackageUid},#{prodPackageServiceUid})";

    //删除产品套餐服务关系信息表
    public static final String DELETE_PROD_PACKAGE_REL = "<script> delete from prod_package_rel where prod_package_uid=#{prodPackageUid} and prod_package_service_uid not in <foreach collection='prodPackageServiceDeleteDTOList' open='(' item='prodPackageService' separator=',' close=')'> #{prodPackageService.objuid}</foreach> </script>";

}
